<?php
$installer = $this;

$installer->startSetup();

$installer->run("
    DROP TABLE IF EXISTS {$this->getTable('temp_price_spr')};
    CREATE TABLE {$this->getTable('temp_price_spr')} (
      `id` int(10) NOT NULL auto_increment,
      `version` varchar(10) default NULL,
      `sku` varchar(20) default NULL,
      `catalogsku` varchar(20) default NULL,
      `upc_code` varchar(10) default NULL,
      `old_sku` varchar(20) default NULL,
      `substitute_skus` varchar(7) default NULL,
      `complimentary_skus` varchar(7) default NULL,
      `catalogpage` varchar(4) default NULL,
      `long_description` text,
      `short_description` varchar(100) default NULL,
      `empty` varchar(50) default NULL,
      `sales_copy` text,
      `keywords` text,
      `ej_image` text,
      `et_image` text,
      `productblock_label` varchar(7) default NULL,
      `productblock_name` varchar(50) default NULL,
      `subclass_label` varchar(7) default NULL,
      `subclass_name` varchar(50) default NULL,
      `class_label` varchar(7) default NULL,
      `class_name` varchar(50) default NULL,
      `department_label` varchar(7) default NULL,
      `department_name` varchar(50) default NULL,
      `singlelevelindexlabel` varchar(7) default NULL,
      `Singlelevelindexname` varchar(50) default NULL,
      `manufacturer_label` varchar(7) default NULL,
      `manufacturer_name` varchar(50) default NULL,
      `manufacturer_prefix` varchar(3) default NULL,
      `minorityownedmanufacturer` varchar(2) default NULL,
      `recycled` varchar(2) default NULL,
      `postconsumerwaste` varchar(3) default NULL,
      `msds_required` varchar(2) default NULL,
      `weight` varchar(8) default NULL,
      `oktoups` varchar(2) default NULL,
      `empty2` varchar(2) default NULL,
      `specialorder` varchar(2) default NULL,
      `assembly_required` varchar(2) default NULL,
      `country` varchar(3) default NULL,
      `list_price` varchar(10) default NULL,
      `Qty` varchar(10) default NULL,
      `um` varchar(3) default NULL,
      `packinglevel1` varchar(20) default NULL,
      `packinglevel2` varchar(20) default NULL,
      `empty3` varchar(10) default NULL,
      `custom` varchar(2) default NULL,
      `color` varchar(50) default NULL,
      `datedgood` varchar(2) default NULL,
      `unspccode` varchar(10) default NULL,
      `schoolsupply` varchar(2) default NULL,
      `totalpercentagerecycledcontent` varchar(3) default NULL,
      `barcodenumber` varchar(10) default NULL,
      `empty4` varchar(2) default NULL,
      `branchonly` varchar(2) default NULL,
      `masterdepartmentlabel` varchar(7) default NULL,
      `masterdepartmentname` varchar(50) default NULL,
      `furniturecatalogsku` varchar(2) default NULL,
      `noreturns` varchar(2) default NULL,
      PRIMARY KEY  (`id`),
      KEY `sku` (`sku`)
    ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
");


$installer->endSetup(); 